SUPPORT / SAMPLES & SAS NOTES
Problem Note 57617: Single-byte and double-byte character set spaces are trimmed differently in SAS® Enterprise Guide® 5.1 as compared to SAS® Enterprise Guide® 7.1
 |  |  |  |
When you use SAS Enterprise Guide to generate a SAS data set and then export it to an XLSX format file, you might notice that single-byte character set (SBCS) and double-byte character set (DBCS) spaces are trimmed differently in SAS Enterprise Guide 7.1 as compared to the 5.1 release.
This behavior applies only to XLSX format.
In SAS Enterprise Guide 5.1
- SBCS space — Any SBCS space in the data set will be trimmed after the data set is exported to an XLSX file.
- DBCS space — Only a leading DBCS space can be exported. Therefore, the variable value has to start with a DBCS space, followed by any other characters. In any other case, a DBCS space is trimmed.
In SAS Enterprise Guide 7.1
- SBCS space — Only a leading SBCS space can be exported. Therefore, a variable value has to start with a SBCS space, followed by any other characters. In any other case, a SBCS space will be trimmed.
- DBCS space — Any DBCS space will remain, which means that no matter what position of the DBCS space the data is in, SAS Enterprise Guide will export it successfully to XLSX format file.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft Windows NT Workstation | 5.1 | |||
| Microsoft Windows 2000 Professional | 5.1 | |||||
| Microsoft Windows 2000 Server | 5.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 5.1 | |||||
| Microsoft Windows 2000 Advanced Server | 5.1 | |||||
| Microsoft Windows 95/98 | 5.1 | |||||
| Microsoft Windows 10 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro 32-bit | 5.1 | |||||
| Microsoft Windows 8 Enterprise x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Enterprise 32-bit | 5.1 | |||||
| Microsoft® Windows® for x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | |||||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | |||||
| Microsoft Windows Server 2003 for x64 | 5.1 | |||||
| Microsoft Windows Server 2008 | 5.1 | |||||
| Microsoft Windows Server 2008 R2 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows XP Professional | 5.1 | |||||
| Windows 7 Enterprise 32 bit | 5.1 | |||||
| Windows 7 Enterprise x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 5.1 | |||||
| Windows 7 Home Premium x64 | 5.1 | |||||
| Windows 7 Professional 32 bit | 5.1 | |||||
| Windows 7 Professional x64 | 5.1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 5.1 | |||||
| Windows 7 Ultimate x64 | 5.1 | |||||
| Windows Millennium Edition (Me) | 5.1 | |||||
| Windows Vista | 5.1 | |||||
| Windows Vista for x64 | 5.1 | |||||